IT257 DATABASE MANAGEMENT SYSTEM

Subject Cordinator: - Dr. Nirav Bhatt

Subject Name: - DATABASE MANAGEMENT SYSTEM

Semester: - 6




Title of the unit Minimum number of hours
1
Introductory concepts of DBMS
06
2 Entity-Relationship model 06
3
Formal Relational Query Languages 		06
4 Relational Database Design 12
5 Transactions 10
6 Concurrency Control 10
7 Recovery System 05
8 Indexing 05


Unit Number Topics Teaching Hours
1
Introductory concepts of DBMS
Introduction and applications of DBMS, Purpose of database, Data Independence, Database System architecture- levels, Mappings, Database users and DBA
06
2 Entity-Relationship model
Basic concepts, Design process, Constraints, Keys, Design issues, E-R diagrams, Weak Entity Sets, Extended E-R features Generalization, Specialization, Aggregation, Reduction to E-R database schema 		06
3
Formal Relational Query Languages
Structure of Relational Databases, Domains, Relations, Relational Algebra fundamental Operators and Syntax, Relational algebra queries 		06
4 Relational Database design
Functional Dependency–definition, Trivial and Non-Trivial FD, Closure of FD set, Closure of attributes, Irreducible set of FD, Normalization – 1NF,2NF,3NF, Decomposition using FD-Dependency Preservation, Multi-valued dependency& 4NF, Join Dependency & 5NF 		12
5 Transactions
Transaction concepts, A Simple Transaction Model, Properties of Transactions, Serializability of transactions, Testing for Serializability 		10
6 Concurrency Control
Lock-Based Protocol, Timestamp-Based Protocol, Multiple Granularity, Deadlock Handling 		10
7 Recovery System
Failure Classification, Recovery and Atomicity, Log-based recovery, Transaction rollback and checkpoints, System recovery 		05
8 Indexing
Basic Concepts, Ordered Indices, B+-Tree Index Files, B-Tree Index Files 		05


Textbooks
Database System Concepts, Abraham Silberschatz, Henry F. Korth & S. Sudarshan, McGraw Hill. Click Here